Si_Packages_Security 
Logical Entity Name  Si_Packages_Security 
Default Table Name  Si_Packages_Security 
Physical Only  NO 
Definition 
 
Note 
 

Si_Packages_Security Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SecurityID(PK)    char(10)  NO 
 
PackageNameId(FK)    char(10)  YES 
 
UIMenuTreeParentSetupID(FK)    char(10)  YES 
 
UIMenuTreeChildSetupID(FK)    char(10)  YES 
 
SyStaffGroupId(FK)    int  NO 
 
Active    char(10)  NO 
 
UserId    char(10)  NO 
 
DateAdded    char(10)  NO 
 
DateLstMod    char(10)  NO 
 
TS    char(10)  NO 
 

Si_Packages_Security Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_Si_Packages_Security_SecurityID  PrimaryKey  SecurityID 

Si_Packages_Security Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Si_Packages_PackageName  Non-Identifying  Zero or One to Zero or More  FK_si_Packages_Security_PackageNameId_si_Packages_PackageName_PackageNameId      PackageNameId  NO  YES 
SyStaffGroup  Non-Identifying  One To Zero or More  FK_si_Packages_Security_SyStaffGroupId_si_Packages_SyStaffGroup_SyStaffGroupId      SyStaffGroupId  NO  YES 
Si_Packages_UIMenuTreeChildSetup  Non-Identifying  Zero or One to Zero or More  FK_si_Packages_Security_UIMenuTreeChildSetupID_si_Packages_UIMenuTreeChildSetup_UIMenuTreeChildSetupID      UIMenuTreeChildSetupID  NO  YES 
Si_Packages_UIMenuTreeParentSetup  Non-Identifying  Zero or One to Zero or More  FK_si_Packages_Security_UIMenuTreeParentSetupID_si_Packages_UIMenuTreeParentSetup_UIMenuTreeParentSetupID      UIMenuTreeParentSetupID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

Si_Packages_Security Check Constraints 
Check Constraint Name  CheckConstraint